The Hazard Classifications report has you select a single hazard classification, then shows which products have one or more items from the selected classification assigned. For each product, the report output can show any or all of the following data:
Common Name
Manufacturer
Revision Date
Internal ID
Primary CAS Number
File Number
Language
Assigned Hazard Classification Item's Code (if selected classification's items have codes)
Assigned Hazard Classification Item's Short Description (if selected classification's items have short descriptions)
Assigned Hazard Classification Item's Long Description (if selected classification's items have long descriptions)
You can also enter criteria for any of the following data types. The report output will include only products that match your criteria in their corresponding data fields.
Product Name
Manufacturer
Internal ID
Ingredients
User-Defined Fields
Hazard Classification Item Code
Hazard Classification Item Short Description
Hazard Classification Item Long Description
Location Assignments
The report output can be generated in any of the following formats: HTML, PDF (requires a PDF-viewing tool, such as Adobe Reader), or Excel (requires Microsoft Excel).
To run the Hazard Classifications report:
Starting at the Reports page
In the list of Product Reports, click Hazard Classifications.
The Hazard Classifications Report page opens, showing the options available for this report.
In the Report output menu, select the desired format for the report output.
To include products no longer used (archived products or products no longer in use at a selected location) in the report output, select Include products no longer used.
Note: If you select this option, each archived product in the report output will be marked with a red asterisk (*).
In the Hazard Classification menu, select a hazard classification. The report output will show only products where one or more of this hazard classification's items are assigned.
To generate the report using default options, skip to step 7. To define options for this report, click Click here for advanced options.
A Report Options area is added to the display.
Enter the desired report options in any or all of the areas provided:
Title: Enter the Report Title and Report Description you want printed at the top of the report output.
Locations: To focus the report on products at certain locations, select the desired location in the menu provided. Repeat to select multiple locations. The report output will include only products assigned to one or more of the selected locations (or to their sub-locations).
Fields and Sorting: This area shows the data fields the report output can display for each product and the selected hazard classification. First, use the Add and Remove buttons to add all desired fields to the Fields and Sort Order list and remove all unwanted fields to the Available Fields list, respectively. When the Fields and Sort Order list contains all (and only) the desired fields, select a field and use the arrow buttons to move the field up or down in the list. Repeat until the fields are in the desired sort order. The report output will be sorted firstly by the first field in the list, secondly by the second field, and so forth. (Example: If Manufacturer is first in the list and Common Name is second, the products in the report output are sorted alphabetically by manufacturer. If two or more products have the same manufacturer, they are sorted alphabetically by common name.)
Note: The report output will show products' assigned hazard classification items only if Item Code, Item Short Description, and/or Item Long Description are placed in the Fields and Sort Order list.
Criteria: In the fields provided, enter one or more criteria. The report output will include only those products that contain all your criteria in the corresponding data fields.
Click Generate Report in the upper right.
The report output generates according to your chosen options and opens in the selected format.
Related Topics